<?php
$sql = "
CREATE TABLE IF NOT EXISTS `ims_yuan_qiandao_sign` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`weid` int(11) DEFAULT '0',
`signactid` int(50) NOT NULL COMMENT '签到关联活动的id，用逗号隔开',
`pointname` varchar(10) NOT NULL COMMENT '积分名称',
`pointshoplink` varchar(10) NOT NULL COMMENT '积分商城链接',
PRIMARY KEY (`id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; 
CREATE TABLE IF NOT EXISTS `ims_yuan_qiandao_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`weid` int(11) DEFAULT '0',
`uid` varchar(50) NOT NULL,
`borntime` varchar(50) NOT NULL,
`getactid` int(11) NOT NULL COMMENT '得到的活动奖励id',
PRIMARY KEY (`id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;  
CREATE TABLE IF NOT EXISTS `ims_yuan_qiandao_activity`(
`id` int(11) NOT NULL AUTO_INCREMENT,
`weid` int(11) DEFAULT '0',
`name` varchar(50) NOT NULL COMMENT '活动介绍',
`daytime` int(50) NOT NULL COMMENT '活动奖励需要连续签到多少天',
`point` int(50) NOT NULL COMMENT '得到的积分',
PRIMARY KEY (`id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
CREATE TABLE IF NOT EXISTS `ims_yuan_qiandao_member`(
`id` int(11) NOT NULL AUTO_INCREMENT,
`weid` int(11) DEFAULT '0',
`uniacid` varchar(50) NOT NULL,
`signday` int(50) NOT NULL COMMENT '连续签到多少天',
`lasttime` varchar(50) NOT NULL COMMENT '最后签到日期',
PRIMARY KEY (`id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
";
pdo_query($sql);